Stored Procedures [dbo].[BAEFieldDesignSectionLookupLoad]
SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEFieldDesignSectionLookupLoad
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@TableNamevarchar(30)30
@FieldNamevarchar(30)30
@FieldSectionIdint4
SQL Script
create procedure [dbo].[BAEFieldDesignSectionLookupLoad] @TableName as
varchar(30),
        @FieldName AS varchar(30),
        @FieldSectionId AS Int
    AS
    SELECT * FROM FieldDesignSectionLookup WHERE TableName = @TableName AND FieldName = @FieldName AND FieldSectionId = @FieldSectionId
    /*SELECT fs.fieldsectionid, fdsl.TableName, fdsl.FieldName, fdsl.Sortorder FROM fieldsection fs
INNER JOIN FieldDesignSectionlookup fdsl on fs.fieldsectionid = fdsl.fieldsectionid
WHERE fdsl.tablename = @TableName AND fdsl.FieldName = @FieldName AND fs.sectionname = @SectionName
*/

GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved